CREATE TABLE [dbo].[PipelineStage]
(
[PipelineStageKey] [uniqueidentifier] NOT NULL,
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PipelineKey] [uniqueidentifier] NOT NULL,
[ComponentKey] [uniqueidentifier] NOT NULL,
[Sequence] [int] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PipelineStage] ADD CONSTRAINT [PK_PipelineStage] PRIMARY KEY CLUSTERED ([PipelineStageKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PipelineStage] ADD CONSTRAINT [AK_PipelineStage_PipelineKey_ComponentKey] UNIQUE NONCLUSTERED ([PipelineKey], [ComponentKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PipelineStage] ADD CONSTRAINT [FK_PipelineStage_ComponentRegistry] FOREIGN KEY ([ComponentKey]) REFERENCES [dbo].[ComponentRegistry] ([ComponentKey])
GO
ALTER TABLE [dbo].[PipelineStage] ADD CONSTRAINT [FK_PipelineStage_Pipeline] FOREIGN KEY ([PipelineKey]) REFERENCES [dbo].[Pipeline] ([PipelineKey])
GO